Computer Science for IGCSE & O level - Databases (Section 5 - No. 19)

What does the `ON DELETE CASCADE` constraint do in a foreign key relationship?

Prevents the deletion of parent records.

Automatically deletes related child records when a parent record is deleted.

Updates the primary key of the child table when the parent key changes.

Allows the deletion of parent records but leaves the child records untouched.

`ON DELETE CASCADE` automatically deletes related child records if the corresponding parent record is deleted.